Wade Smart wrote: > You fingered it Joe. I checked the column and its formated as date. > I copied the number over to a new column formatted as text and it works > great. > > Question: how do you reformat as text without loosing all the data?
Select the cells, 'Copy', reformat cells as desired, 'Paste Special' > uncheck all but 'Text'? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
