Hi, I've got a large survey data-set in Excel 2003. Some values are
pure text, some are numbers but were recorded as text. There are also
many blanks in each collumn.
So, I am trying to convert the numbers from text format to a number
format. I know the basic tricks (=VALUE(), or Type 1, Copy, Paste
Special--> Multiply + Value). The only problem is that all of them
convert a blank into a 0. I really need to keep the blanks as blanks.
Does anyone have a trick or a macro that would make sure that blanks
remain as blanks when converting text to number? Thank you!

If you copy an empty cell, select the range and do edit>paste special and
select add it will not change blank cells to 0 but it will change any text
number. Another good trick is to select the column/range and do data>text to
columns and click finish immediately


--
Regards,

Peo Sjoblom


"Anika V. Bristalli" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi, I've got a large survey data-set in Excel 2003. Some values are
> pure text, some are numbers but were recorded as text. There are also
> many blanks in each collumn.
> So, I am trying to convert the numbers from text format to a number
> format. I know the basic tricks (=VALUE(), or Type 1, Copy, Paste
> Special--> Multiply + Value). The only problem is that all of them
> convert a blank into a 0. I really need to keep the blanks as blanks.
> Does anyone have a trick or a macro that would make sure that blanks
> remain as blanks when converting text to number? Thank you!
>

The first option works great - thank you!!!



On Aug 15, 1:41 pm, "Peo Sjoblom" <terr...@mvps.org> wrote:
> If you copy an empty cell, select the range and do edit>paste special and
> select add it will not change blank cells to 0 but it will change any text
> number. Another good trick is to select the column/range and do data>text to
> columns and click finish immediately
>
> --
> Regards,
>
> Peo Sjoblom
>
> "Anika V. Bristalli" <vassi...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> > Hi, I've got a large survey data-set in Excel 2003. Some values are
> > pure text, some are numbers but were recorded as text. There are also
> > many blanks in each collumn.
> > So, I am trying to convert the numbers from text format to a number
> > format. I know the basic tricks (=VALUE(), or Type 1, Copy, Paste
> > Special--> Multiply + Value). The only problem is that all of them
> > convert a blank into a 0. I really need to keep the blanks as blanks.
> > Does anyone have a trick or a macro that would make sure that blanks
> > remain as blanks when converting text to number? Thank you!- Hide quoted text -
>
> - Show quoted text -