![]() |
![]() |
#1 | ||
n00b
Join Date: Nov 2003
|
Simple Excel Question
I need to input some ISBN values in Excel. Problem is that some ISBN values contain a 0 as the first number (0752816144) and Excel automatically removes them (752816144). I have looked at the AutoCorrect features but it is not listed there. How can I get Excel to include the zero?
|
||
![]() |
![]() |
![]() |
#2 |
High School Varsity
Join Date: Aug 2003
|
Easiest way is to highlight that column, then click on Format... Cells... and change it to a text column.
|
![]() |
![]() |
![]() |
#3 | |
Dearly Missed
(9/25/77-12/23/08) Join Date: Nov 2003
Location: DC Suburbs
|
Quote:
put a single quote in front of it like: '0752816144
__________________
NAFL New Orleans Saints GM/Co-Commish MP Career Record: 114-85 NAFL Super Bowl XI Champs In memory of Gavin Anthony: 7/22/08-7/26/08 |
|
![]() |
![]() |
![]() |
#4 |
n00b
Join Date: Nov 2003
|
Thanks both, I had tried to use " in front of the ISBN-number as that was how it was in the Works Database I used to use.
|
![]() |
![]() |
![]() |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|