Formatting Numbers in Excel

  • Thread starter Thread starter Julia Easter
  • Start date Start date
J

Julia Easter

Hi - not sure if I have the answer or not!!

I am preparing a spread sheet thet will be sent as a CSV
file containing bank details

I am having a problem because when I extract data into
excel from a Sage Database the bank sort code number is
randomley being changed to a date - I worked out this is
because some of them look like a date - e.g 07-08-50

1st solution - take the dashes out..... works BUT cant
have a number beginning with 0

2nd Solution - change the format of the cell to "Text"
rather than number...... will this affect the receiver of
the CVS file?

Any idea's or thoughts on other ways around this problem?

Thanks
Julia
 
Julia,

Your second solution is the corret one, and no, it will not affect the .csv
file; by definirtion, .csv files are just plain text files, so no formatting
information is contained in them anyway.

HTH,
Nikos
 
Back
Top